#! /bin/bash
export LANG=zh_CN.UTF-8
PRESTO_HOME=/export/server/presto/bin/presto


${PRESTO_HOME} --catalog hive --server 192.168.88.80:8090 --execute "
insert into hive.edu_dwb.kxh_dwb_web_chat_ems_wide
select a.id,
       session_id,
       sid,
       create_time,
       seo_source,
       ip,
       area,
       origin_channel,
       msg_count,
       from_url
from hive.edu_dwd.kxh_fact_web_chat_ems a
join hive.edu_dwd.kxh_fact_web_chat_text_ems b
on a.id=b.id;
"